دانلود کتاب اوراکل-دانلود کتاب oracle-Oracle Essentials

1. Introducing Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
The Evolution of the Relational Database 2
The Oracle Database Family 7
Summary of Oracle Database Features 9
Database Application Development Features 9
Database Connection Features 13
Distributed Database Features 17
Data Movement Features 18
Database Performance Features 20
Database Management Features 23
Database Security Features 27
Oracle Development Tools 28
Embedded Databases 31
2. Oracle Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Databases and Instances 33
Deploying Physical Components 38
Instance Memory and Processes 48
The Data Dictionary 54
3. Installing and Running Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
Installing Oracle 56
Creating a Database 59
Configuring Oracle Net 63

Starting Up the Database 68
Shutting Down the Database 69
Accessing a Database 70
Oracle at Work 77
4. Oracle Data Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
Datatypes 82
Basic Data Structures 90
Additional Data Structures 98
Extended Logic for Data 100
Data Design 102
Constraints 104
Triggers 107
Query Optimization 108
Understanding the Execution Plan 118
SQL Advisors 120
Data Dictionary Tables 120
5. Managing Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122
Manageability Features 124
Oracle Enterprise Manager 126
Fragmentation and Reorganization 132
Backup and Recovery 133
Working with Oracle Support 137
6. Oracle Security, Auditing, and Compliance . . . . . . . . . . . . . . . . . . . . . . . . . . . 139
Security 139
Auditing 150
Compliance 151
7. Oracle Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154
Performance Tuning Basics 154
Oracle and Disk I/O Resources 160
Oracle and Parallelism 169
Oracle and Memory Resources 176
Oracle and CPU Resources 182
Database Resource Manager 184